package cqrtplm.mapper;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.math.BigInteger;
import java.util.List;

@Mapper
public interface RTPlanPublishMapper {

    List<BigInteger> selectJobById(BigInteger prj);

    @Select("select CONTAINEROID from TY_WORKFLOW_CONTAINER where OID=TO_NUMBER(#{workFlowContainerId})")
    BigInteger selectPrjById(String workFlowContainerId);

    void updateJobPublish(@Param("planOids") List<BigInteger> planOids);

    @Select("select ATTRIBUTEVALUE from VIEW_TY_IBA where OBJBASEOID=#{prj} AND ATTRIBUTEENNAME='ExecutionStatus'")
    String selectPrjIba(BigInteger prj);

}
